IF EXISTS (SELECT * FROM sysobjects WHERE type = 'P' AND name = 'spSys_UserUpdate')
	BEGIN
		DROP  Procedure  spSys_UserUpdate
	END
GO
-- =============================================
-- Author:		NAMTRANPHUONG
-- Create date: August 18, 2012
-- Description:	Select Group user infor
-- =============================================
CREATE PROCEDURE spSys_UserUpdate
	@UserId INT,
	@Username NVARCHAR(200),
	@Password NVARCHAR(32),
	@DisplayName NVARCHAR(200),
	@Email NVARCHAR(100),
	@Mobile VARCHAR(50),
	@Address NVARCHAR(300),
	@CreatedDate DATETIME,
	@CreatedBy INT,
	@Status SMALLINT
AS
BEGIN
	UPDATE Sys_User
	SET [Username] = @Username
      ,[Password] = @Password
      ,[DisplayName] = @DisplayName
      ,[Email] = @Email
      ,[Mobile] = @Mobile
      ,[Address] = @Address
      ,[CreatedDate] = GETDATE()
      ,[CreatedBy] = @CreatedBy
      ,[Status] = @Status
	WHERE UserId = @UserId
	
END
GO
